To drop a field from a specific table, do the following: Open Microsoft Sql Server Management Studio Connect to the desired database and create a new query Paste the following in the window: ALTER TABLE [TableName] DROP COLUMN [ColumnName] Execute the query